100 |
It seems that the control uses the TAB key, is there any way to avoid that
|
99 |
How do I assign a database to your control, using ADO, ADOR or ADODB objects
#include "AppEvent.ch" #include "ActiveX.ch" PROCEDURE Main LOCAL oForm LOCAL nEvent := 0, mp1 := NIL, mp2 := NIL, oXbp := NIL LOCAL oComboBox LOCAL rs oForm := XbpDialog():new( AppDesktop() ) oForm:drawingArea:clipChildren := .T. oForm:create( ,,{100,100}, {640,480},, .F. ) oForm:close := {|| PostAppEvent( xbeP_Quit )} oComboBox := XbpActiveXControl():new( oForm:drawingArea ) oComboBox:CLSID := "Exontrol.ComboBox.1" /*{CF170E7A-4391-44BD-8D93-29F8D2801EF7}*/ oComboBox:create(,, {10,60},{610,370} ) oComboBox:ColumnAutoResize := .F. rs := CreateObject("ADOR.Recordset") rs:Open("Orders","Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Program Files\Exontrol\ExComboBox\Sample\Access\SAMPLE.MDB",3/*adOpenStatic*/,3/*adLockOptimistic*/) oComboBox:DataSource := rs oForm:Show() DO WHILE nEvent != xbeP_Quit nEvent := AppEvent( @mp1, @mp2, @oXbp ) oXbp:handleEvent( nEvent, mp1, mp2 ) ENDDO RETURN |
98 |
How do I change the visual appearance effect for the selected item, using EBN
|
97 |
How do I change the colors for the selected item
#include "AppEvent.ch" #include "ActiveX.ch" PROCEDURE Main LOCAL oForm LOCAL nEvent := 0, mp1 := NIL, mp2 := NIL, oXbp := NIL LOCAL oComboBox oForm := XbpDialog():new( AppDesktop() ) oForm:drawingArea:clipChildren := .T. oForm:create( ,,{100,100}, {640,480},, .F. ) oForm:close := {|| PostAppEvent( xbeP_Quit )} oComboBox := XbpActiveXControl():new( oForm:drawingArea ) oComboBox:CLSID := "Exontrol.ComboBox.1" /*{CF170E7A-4391-44BD-8D93-29F8D2801EF7}*/ oComboBox:create(,, {10,60},{610,370} ) oComboBox:SetProperty("SelBackColor",AutomationTranslateColor( GraMakeRGBColor ( { 0,0,0 } ) , .F. )) oComboBox:Columns():Add("Column") oComboBox:Items():AddItem(0) oComboBox:Items():AddItem(1) oForm:Show() DO WHILE nEvent != xbeP_Quit nEvent := AppEvent( @mp1, @mp2, @oXbp ) oXbp:handleEvent( nEvent, mp1, mp2 ) ENDDO RETURN |
96 |
How do I get ride of the rectangle arround focused item
|
95 |
How can I change the control's font
|
94 |
I can't scroll to the end of the data. What can I do
|
93 |
How do I specify the column where the tree lines / hierarchy are shown
#include "AppEvent.ch" #include "ActiveX.ch" PROCEDURE Main LOCAL oForm LOCAL nEvent := 0, mp1 := NIL, mp2 := NIL, oXbp := NIL LOCAL oComboBox LOCAL oItems LOCAL h oForm := XbpDialog():new( AppDesktop() ) oForm:drawingArea:clipChildren := .T. oForm:create( ,,{100,100}, {640,480},, .F. ) oForm:close := {|| PostAppEvent( xbeP_Quit )} oComboBox := XbpActiveXControl():new( oForm:drawingArea ) oComboBox:CLSID := "Exontrol.ComboBox.1" /*{CF170E7A-4391-44BD-8D93-29F8D2801EF7}*/ oComboBox:create(,, {10,60},{610,370} ) oComboBox:LinesAtRoot := 1/*exGroupLinesAtRoot*/ oComboBox:TreeColumnIndex := 1 oComboBox:Columns():Add("Column 1") oComboBox:Columns():Add("Column 2") oItems := oComboBox:Items() h := oItems:AddItem("Root 1.1") oItems:SetProperty("CellCaption",h,1,"Root 1.2") oItems:SetProperty("CellCaption",oItems:InsertItem(h,,"Child 1.1"),1,"Child 1.2") oItems:SetProperty("CellCaption",oItems:InsertItem(h,,"Child 2.1"),1,"Child 2.2") oItems:SetProperty("ExpandItem",h,.T.) h := oItems:AddItem("Root 2.1") oItems:SetProperty("CellCaption",h,1,"Root 2.2") oItems:SetProperty("CellCaption",oItems:InsertItem(h,,"Child 1.1"),1,"Child 1.2") oForm:Show() DO WHILE nEvent != xbeP_Quit nEvent := AppEvent( @mp1, @mp2, @oXbp ) oXbp:handleEvent( nEvent, mp1, mp2 ) ENDDO RETURN |
92 |
How do I specify the indentation of the child items relative to their parents
#include "AppEvent.ch" #include "ActiveX.ch" PROCEDURE Main LOCAL oForm LOCAL nEvent := 0, mp1 := NIL, mp2 := NIL, oXbp := NIL LOCAL oComboBox LOCAL oItems LOCAL h oForm := XbpDialog():new( AppDesktop() ) oForm:drawingArea:clipChildren := .T. oForm:create( ,,{100,100}, {640,480},, .F. ) oForm:close := {|| PostAppEvent( xbeP_Quit )} oComboBox := XbpActiveXControl():new( oForm:drawingArea ) oComboBox:CLSID := "Exontrol.ComboBox.1" /*{CF170E7A-4391-44BD-8D93-29F8D2801EF7}*/ oComboBox:create(,, {10,60},{610,370} ) oComboBox:LinesAtRoot := 1/*exGroupLinesAtRoot*/ oComboBox:Indent := 11 oComboBox:Columns():Add("Column") oItems := oComboBox:Items() h := oItems:AddItem("Root 1") oItems:InsertItem(h,,"Child 1") oItems:InsertItem(h,,"Child 2") oItems:SetProperty("ExpandItem",h,.T.) h := oItems:AddItem("Root 2") oItems:InsertItem(h,,"Child") oForm:Show() DO WHILE nEvent != xbeP_Quit nEvent := AppEvent( @mp1, @mp2, @oXbp ) oXbp:handleEvent( nEvent, mp1, mp2 ) ENDDO RETURN |
91 |
How can I programmatically change the column where incremental searching is performed
|
90 |
How do I disable the full-row selection in the control
|
89 |
Is there any option to specify the height of the items, before adding them
|
88 |
How do lock / fix some columns to the control, so I can see them all the time, event if I scroll the columns
|
87 |
How do I change the control's background / foreground color on the locked area
|
86 |
How do I change the control's foreground color
#include "AppEvent.ch" #include "ActiveX.ch" PROCEDURE Main LOCAL oForm LOCAL nEvent := 0, mp1 := NIL, mp2 := NIL, oXbp := NIL LOCAL oComboBox oForm := XbpDialog():new( AppDesktop() ) oForm:drawingArea:clipChildren := .T. oForm:create( ,,{100,100}, {640,480},, .F. ) oForm:close := {|| PostAppEvent( xbeP_Quit )} oComboBox := XbpActiveXControl():new( oForm:drawingArea ) oComboBox:CLSID := "Exontrol.ComboBox.1" /*{CF170E7A-4391-44BD-8D93-29F8D2801EF7}*/ oComboBox:create(,, {10,60},{610,370} ) oComboBox:SetProperty("ForeColor",AutomationTranslateColor( GraMakeRGBColor ( { 120,120,120 } ) , .F. )) oComboBox:Columns():Add("Column") oComboBox:Items():AddItem("item") oForm:Show() DO WHILE nEvent != xbeP_Quit nEvent := AppEvent( @mp1, @mp2, @oXbp ) oXbp:handleEvent( nEvent, mp1, mp2 ) ENDDO RETURN |
85 |
How do I change the control's background color
#include "AppEvent.ch" #include "ActiveX.ch" PROCEDURE Main LOCAL oForm LOCAL nEvent := 0, mp1 := NIL, mp2 := NIL, oXbp := NIL LOCAL oComboBox oForm := XbpDialog():new( AppDesktop() ) oForm:drawingArea:clipChildren := .T. oForm:create( ,,{100,100}, {640,480},, .F. ) oForm:close := {|| PostAppEvent( xbeP_Quit )} oComboBox := XbpActiveXControl():new( oForm:drawingArea ) oComboBox:CLSID := "Exontrol.ComboBox.1" /*{CF170E7A-4391-44BD-8D93-29F8D2801EF7}*/ oComboBox:create(,, {10,60},{610,370} ) oComboBox:SetProperty("BackColor",AutomationTranslateColor( GraMakeRGBColor ( { 200,200,200 } ) , .F. )) oForm:Show() DO WHILE nEvent != xbeP_Quit nEvent := AppEvent( @mp1, @mp2, @oXbp ) oXbp:handleEvent( nEvent, mp1, mp2 ) ENDDO RETURN |
84 |
How do I use my own icons for my radio buttons
|
83 |
How do I use my own icons for checkbox cells
|
82 |
How do I perform my own sorting when user clicks the column's header
|
81 |
How do I disable sorting a specified column when clicking its header
|
80 |
How do I disable sorting the columns when clicking the control's header
|
79 |
How do I sort descending a column, and put the sorting icon in the column's header
|
78 |
How do I sort ascending a column, and put the sorting icon in the column's header
|
77 |
How do I perform my own/custom sort, using my extra strings
#include "AppEvent.ch" #include "ActiveX.ch" PROCEDURE Main LOCAL oForm LOCAL nEvent := 0, mp1 := NIL, mp2 := NIL, oXbp := NIL LOCAL oComboBox LOCAL oItems oForm := XbpDialog():new( AppDesktop() ) oForm:drawingArea:clipChildren := .T. oForm:create( ,,{100,100}, {640,480},, .F. ) oForm:close := {|| PostAppEvent( xbeP_Quit )} oComboBox := XbpActiveXControl():new( oForm:drawingArea ) oComboBox:CLSID := "Exontrol.ComboBox.1" /*{CF170E7A-4391-44BD-8D93-29F8D2801EF7}*/ oComboBox:create(,, {10,60},{610,370} ) oComboBox:Columns():Add("desc"):SortType := 5/*SortUserData*/ oItems := oComboBox:Items() oItems:SetProperty("CellData",oItems:AddItem("A"),0,"C") oItems:SetProperty("CellData",oItems:AddItem("B"),0,"B") oItems:SetProperty("CellData",oItems:AddItem("C"),0,"A") oItems:SortChildren(0,0,.F.) oForm:Show() DO WHILE nEvent != xbeP_Quit nEvent := AppEvent( @mp1, @mp2, @oXbp ) oXbp:handleEvent( nEvent, mp1, mp2 ) ENDDO RETURN |
76 |
How do I perform my own/custom sort, using my extra numbers
#include "AppEvent.ch" #include "ActiveX.ch" PROCEDURE Main LOCAL oForm LOCAL nEvent := 0, mp1 := NIL, mp2 := NIL, oXbp := NIL LOCAL oComboBox LOCAL oItems oForm := XbpDialog():new( AppDesktop() ) oForm:drawingArea:clipChildren := .T. oForm:create( ,,{100,100}, {640,480},, .F. ) oForm:close := {|| PostAppEvent( xbeP_Quit )} oComboBox := XbpActiveXControl():new( oForm:drawingArea ) oComboBox:CLSID := "Exontrol.ComboBox.1" /*{CF170E7A-4391-44BD-8D93-29F8D2801EF7}*/ oComboBox:create(,, {10,60},{610,370} ) oComboBox:Columns():Add("desc"):SortType := 5/*SortUserData*/ oItems := oComboBox:Items() oItems:SetProperty("CellData",oItems:AddItem(0),0,2) oItems:SetProperty("CellData",oItems:AddItem(1),0,1) oItems:SetProperty("CellData",oItems:AddItem(2),0,0) oItems:SortChildren(0,0,.F.) oForm:Show() DO WHILE nEvent != xbeP_Quit nEvent := AppEvent( @mp1, @mp2, @oXbp ) oXbp:handleEvent( nEvent, mp1, mp2 ) ENDDO RETURN |
75 |
By default, the column gets sorted as strings, so how do I sort a column by time only
#include "AppEvent.ch" #include "ActiveX.ch" PROCEDURE Main LOCAL oForm LOCAL nEvent := 0, mp1 := NIL, mp2 := NIL, oXbp := NIL LOCAL oComboBox LOCAL oItems oForm := XbpDialog():new( AppDesktop() ) oForm:drawingArea:clipChildren := .T. oForm:create( ,,{100,100}, {640,480},, .F. ) oForm:close := {|| PostAppEvent( xbeP_Quit )} oComboBox := XbpActiveXControl():new( oForm:drawingArea ) oComboBox:CLSID := "Exontrol.ComboBox.1" /*{CF170E7A-4391-44BD-8D93-29F8D2801EF7}*/ oComboBox:create(,, {10,60},{610,370} ) oComboBox:Columns():Add("desc"):SortType := 4/*SortTime*/ oItems := oComboBox:Items() oItems:AddItem("11:00") oItems:AddItem("10:10") oItems:AddItem("12:12") oItems:SortChildren(0,0,.F.) oForm:Show() DO WHILE nEvent != xbeP_Quit nEvent := AppEvent( @mp1, @mp2, @oXbp ) oXbp:handleEvent( nEvent, mp1, mp2 ) ENDDO RETURN |
74 |
By default, the column gets sorted as strings, so how do I sort a column by date and time
#include "AppEvent.ch" #include "ActiveX.ch" PROCEDURE Main LOCAL oForm LOCAL nEvent := 0, mp1 := NIL, mp2 := NIL, oXbp := NIL LOCAL oComboBox LOCAL oItems oForm := XbpDialog():new( AppDesktop() ) oForm:drawingArea:clipChildren := .T. oForm:create( ,,{100,100}, {640,480},, .F. ) oForm:close := {|| PostAppEvent( xbeP_Quit )} oComboBox := XbpActiveXControl():new( oForm:drawingArea ) oComboBox:CLSID := "Exontrol.ComboBox.1" /*{CF170E7A-4391-44BD-8D93-29F8D2801EF7}*/ oComboBox:create(,, {10,60},{610,370} ) oComboBox:Columns():Add("desc"):SortType := 3/*SortDateTime*/ oItems := oComboBox:Items() oItems:AddItem("1/1/2001 11:00") oItems:AddItem("1/1/2001 10:10") oItems:AddItem("1/3/2003") oItems:SortChildren(0,0,.F.) oForm:Show() DO WHILE nEvent != xbeP_Quit nEvent := AppEvent( @mp1, @mp2, @oXbp ) oXbp:handleEvent( nEvent, mp1, mp2 ) ENDDO RETURN |
73 |
By default, the column gets sorted as strings, so how do I sort a column by dates
#include "AppEvent.ch" #include "ActiveX.ch" PROCEDURE Main LOCAL oForm LOCAL nEvent := 0, mp1 := NIL, mp2 := NIL, oXbp := NIL LOCAL oComboBox LOCAL oItems oForm := XbpDialog():new( AppDesktop() ) oForm:drawingArea:clipChildren := .T. oForm:create( ,,{100,100}, {640,480},, .F. ) oForm:close := {|| PostAppEvent( xbeP_Quit )} oComboBox := XbpActiveXControl():new( oForm:drawingArea ) oComboBox:CLSID := "Exontrol.ComboBox.1" /*{CF170E7A-4391-44BD-8D93-29F8D2801EF7}*/ oComboBox:create(,, {10,60},{610,370} ) oComboBox:Columns():Add("desc"):SortType := 2/*SortDate*/ oItems := oComboBox:Items() oItems:AddItem("1/1/2001") oItems:AddItem("1/2/2002") oItems:AddItem("1/3/2003") oItems:SortChildren(0,0,.F.) oForm:Show() DO WHILE nEvent != xbeP_Quit nEvent := AppEvent( @mp1, @mp2, @oXbp ) oXbp:handleEvent( nEvent, mp1, mp2 ) ENDDO RETURN |
72 |
How do I sort a column by numbers
#include "AppEvent.ch" #include "ActiveX.ch" PROCEDURE Main LOCAL oForm LOCAL nEvent := 0, mp1 := NIL, mp2 := NIL, oXbp := NIL LOCAL oComboBox LOCAL oItems oForm := XbpDialog():new( AppDesktop() ) oForm:drawingArea:clipChildren := .T. oForm:create( ,,{100,100}, {640,480},, .F. ) oForm:close := {|| PostAppEvent( xbeP_Quit )} oComboBox := XbpActiveXControl():new( oForm:drawingArea ) oComboBox:CLSID := "Exontrol.ComboBox.1" /*{CF170E7A-4391-44BD-8D93-29F8D2801EF7}*/ oComboBox:create(,, {10,60},{610,370} ) oComboBox:Columns():Add("desc"):SortType := 1/*SortNumeric*/ oItems := oComboBox:Items() oItems:AddItem(1) oItems:AddItem(5) oItems:AddItem(10) oItems:SortChildren(0,0,.F.) oForm:Show() DO WHILE nEvent != xbeP_Quit nEvent := AppEvent( @mp1, @mp2, @oXbp ) oXbp:handleEvent( nEvent, mp1, mp2 ) ENDDO RETURN |
71 |
How do I hide the control's header bar
|
70 |
How do change the visual appearance for the control's header bar, using EBN
|
69 |
How do I remove the control's border
|
68 |
I have a hierarchy and I need to filter only root items that match, with thier childs
#include "AppEvent.ch" #include "ActiveX.ch" PROCEDURE Main LOCAL oForm LOCAL nEvent := 0, mp1 := NIL, mp2 := NIL, oXbp := NIL LOCAL oComboBox LOCAL oColumn LOCAL oItems LOCAL h oForm := XbpDialog():new( AppDesktop() ) oForm:drawingArea:clipChildren := .T. oForm:create( ,,{100,100}, {640,480},, .F. ) oForm:close := {|| PostAppEvent( xbeP_Quit )} oComboBox := XbpActiveXControl():new( oForm:drawingArea ) oComboBox:CLSID := "Exontrol.ComboBox.1" /*{CF170E7A-4391-44BD-8D93-29F8D2801EF7}*/ oComboBox:create(,, {10,60},{610,370} ) oComboBox:LinesAtRoot := -1/*exLinesAtRoot*/ oComboBox:FilterInclude := 3/*exRootsWithChilds*/ oColumn := oComboBox:Columns():Add("Column") oColumn:DisplayFilterButton := .T. oColumn:FilterType := 240/*exFilter*/ oColumn:Filter := "R1" oItems := oComboBox:Items() h := oItems:AddItem("R1") oItems:InsertItem(h,,"C1") oItems:InsertItem(h,,"C2") oItems:SetProperty("ExpandItem",h,.T.) h := oItems:AddItem("R2") oItems:InsertItem(h,,"C1") oItems:InsertItem(h,,"C2") oComboBox:ApplyFilter() oForm:Show() DO WHILE nEvent != xbeP_Quit nEvent := AppEvent( @mp1, @mp2, @oXbp ) oXbp:handleEvent( nEvent, mp1, mp2 ) ENDDO RETURN |
67 |
I have a hierarchy and I need to filter only root items that match, without thier childs
#include "AppEvent.ch" #include "ActiveX.ch" PROCEDURE Main LOCAL oForm LOCAL nEvent := 0, mp1 := NIL, mp2 := NIL, oXbp := NIL LOCAL oComboBox LOCAL oColumn LOCAL oItems LOCAL h oForm := XbpDialog():new( AppDesktop() ) oForm:drawingArea:clipChildren := .T. oForm:create( ,,{100,100}, {640,480},, .F. ) oForm:close := {|| PostAppEvent( xbeP_Quit )} oComboBox := XbpActiveXControl():new( oForm:drawingArea ) oComboBox:CLSID := "Exontrol.ComboBox.1" /*{CF170E7A-4391-44BD-8D93-29F8D2801EF7}*/ oComboBox:create(,, {10,60},{610,370} ) oComboBox:LinesAtRoot := -1/*exLinesAtRoot*/ oComboBox:FilterInclude := 2/*exRootsWithoutChilds*/ oColumn := oComboBox:Columns():Add("Column") oColumn:DisplayFilterButton := .T. oColumn:FilterType := 240/*exFilter*/ oColumn:Filter := "R1" oItems := oComboBox:Items() h := oItems:AddItem("R1") oItems:InsertItem(h,,"C1") oItems:InsertItem(h,,"C2") oItems:SetProperty("ExpandItem",h,.T.) h := oItems:AddItem("R2") oItems:InsertItem(h,,"C1") oItems:InsertItem(h,,"C2") oComboBox:ApplyFilter() oForm:Show() DO WHILE nEvent != xbeP_Quit nEvent := AppEvent( @mp1, @mp2, @oXbp ) oXbp:handleEvent( nEvent, mp1, mp2 ) ENDDO RETURN |
66 |
I have a hierarchy and I need to filter only parent items that match, including thier childs
#include "AppEvent.ch" #include "ActiveX.ch" PROCEDURE Main LOCAL oForm LOCAL nEvent := 0, mp1 := NIL, mp2 := NIL, oXbp := NIL LOCAL oComboBox LOCAL oColumn LOCAL oItems LOCAL h oForm := XbpDialog():new( AppDesktop() ) oForm:drawingArea:clipChildren := .T. oForm:create( ,,{100,100}, {640,480},, .F. ) oForm:close := {|| PostAppEvent( xbeP_Quit )} oComboBox := XbpActiveXControl():new( oForm:drawingArea ) oComboBox:CLSID := "Exontrol.ComboBox.1" /*{CF170E7A-4391-44BD-8D93-29F8D2801EF7}*/ oComboBox:create(,, {10,60},{610,370} ) oComboBox:LinesAtRoot := -1/*exLinesAtRoot*/ oComboBox:FilterInclude := 1/*exItemsWithChilds*/ oColumn := oComboBox:Columns():Add("Column") oColumn:DisplayFilterButton := .T. oColumn:FilterType := 240/*exFilter*/ oColumn:Filter := "R1" oItems := oComboBox:Items() h := oItems:AddItem("R1") oItems:InsertItem(h,,"C1") oItems:InsertItem(h,,"C2") oItems:SetProperty("ExpandItem",h,.T.) h := oItems:AddItem("R2") oItems:InsertItem(h,,"C1") oItems:InsertItem(h,,"C2") oComboBox:ApplyFilter() oForm:Show() DO WHILE nEvent != xbeP_Quit nEvent := AppEvent( @mp1, @mp2, @oXbp ) oXbp:handleEvent( nEvent, mp1, mp2 ) ENDDO RETURN |
65 |
How can I get ride/hide of the "Filter For" field
|
64 |
Is there any way to get listed only visible items in the drop down filter window
#include "AppEvent.ch" #include "ActiveX.ch" PROCEDURE Main LOCAL oForm LOCAL nEvent := 0, mp1 := NIL, mp2 := NIL, oXbp := NIL LOCAL oComboBox LOCAL oColumn,oColumn1 LOCAL oItems LOCAL h oForm := XbpDialog():new( AppDesktop() ) oForm:drawingArea:clipChildren := .T. oForm:create( ,,{100,100}, {640,480},, .F. ) oForm:close := {|| PostAppEvent( xbeP_Quit )} oComboBox := XbpActiveXControl():new( oForm:drawingArea ) oComboBox:CLSID := "Exontrol.ComboBox.1" /*{CF170E7A-4391-44BD-8D93-29F8D2801EF7}*/ oComboBox:create(,, {10,60},{610,370} ) oComboBox:LinesAtRoot := -1/*exLinesAtRoot*/ oComboBox:SetProperty("Description",0/*exFilterBarAll*/,"") oComboBox:SetProperty("Description",1/*exFilterBarBlanks*/,"") oComboBox:SetProperty("Description",2/*exFilterBarNonBlanks*/,"") oColumn := oComboBox:Columns():Add("P1") oColumn:DisplayFilterButton := .T. oColumn:DisplayFilterPattern := .F. oColumn:FilterList := 1/*exVisibleItems*/ oColumn1 := oComboBox:Columns():Add("P2") oColumn1:DisplayFilterButton := .T. oColumn1:DisplayFilterPattern := .F. oItems := oComboBox:Items() h := oItems:AddItem("R1") oItems:SetProperty("CellCaption",h,1,"R2") oItems:SetProperty("CellCaption",oItems:InsertItem(h,,"Cell 1.1"),1,"Cell 1.2") oItems:SetProperty("CellCaption",oItems:InsertItem(h,,"Cell 2.1"),1,"Cell 2.2") oForm:Show() DO WHILE nEvent != xbeP_Quit nEvent := AppEvent( @mp1, @mp2, @oXbp ) oXbp:handleEvent( nEvent, mp1, mp2 ) ENDDO RETURN |
63 |
How do I filter for items that match exactly the specified string
#include "AppEvent.ch" #include "ActiveX.ch" PROCEDURE Main LOCAL oForm LOCAL nEvent := 0, mp1 := NIL, mp2 := NIL, oXbp := NIL LOCAL oComboBox LOCAL oColumn oForm := XbpDialog():new( AppDesktop() ) oForm:drawingArea:clipChildren := .T. oForm:create( ,,{100,100}, {640,480},, .F. ) oForm:close := {|| PostAppEvent( xbeP_Quit )} oComboBox := XbpActiveXControl():new( oForm:drawingArea ) oComboBox:CLSID := "Exontrol.ComboBox.1" /*{CF170E7A-4391-44BD-8D93-29F8D2801EF7}*/ oComboBox:create(,, {10,60},{610,370} ) oColumn := oComboBox:Columns():Add("Column") oColumn:DisplayFilterButton := .T. oColumn:FilterType := 240/*exFilter*/ oColumn:Filter := "Item 1" oComboBox:Items():AddItem("Item 1") oComboBox:Items():AddItem("Item 2") oComboBox:Items():AddItem("Item 3") oComboBox:ApplyFilter() oForm:Show() DO WHILE nEvent != xbeP_Quit nEvent := AppEvent( @mp1, @mp2, @oXbp ) oXbp:handleEvent( nEvent, mp1, mp2 ) ENDDO RETURN |
62 |
How can I can I programmatically filter for items with a specified icon assigned
#include "AppEvent.ch" #include "ActiveX.ch" PROCEDURE Main LOCAL oForm LOCAL nEvent := 0, mp1 := NIL, mp2 := NIL, oXbp := NIL LOCAL oComboBox LOCAL oColumn LOCAL oItems oForm := XbpDialog():new( AppDesktop() ) oForm:drawingArea:clipChildren := .T. oForm:create( ,,{100,100}, {640,480},, .F. ) oForm:close := {|| PostAppEvent( xbeP_Quit )} oComboBox := XbpActiveXControl():new( oForm:drawingArea ) oComboBox:CLSID := "Exontrol.ComboBox.1" /*{CF170E7A-4391-44BD-8D93-29F8D2801EF7}*/ oComboBox:create(,, {10,60},{610,370} ) oComboBox:Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTqlVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/yNAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=") oColumn := oComboBox:Columns():Add("Column") oColumn:DisplayFilterButton := .T. oColumn:FilterType := 10/*exImage*/ oColumn:Filter := Transform(1,"") oItems := oComboBox:Items() oItems:SetProperty("CellImage",oItems:AddItem("Image 1"),0,1) oItems:SetProperty("CellImage",oItems:AddItem("Image 1"),0,1) oItems:SetProperty("CellImage",oItems:AddItem("Image 2"),0,2) oItems:SetProperty("CellImage",oItems:AddItem("Image 3"),0,3) oComboBox:ApplyFilter() oForm:Show() DO WHILE nEvent != xbeP_Quit nEvent := AppEvent( @mp1, @mp2, @oXbp ) oXbp:handleEvent( nEvent, mp1, mp2 ) ENDDO RETURN |
61 |
How can I can I programmatically filter the checked items
#include "AppEvent.ch" #include "ActiveX.ch" PROCEDURE Main LOCAL oForm LOCAL nEvent := 0, mp1 := NIL, mp2 := NIL, oXbp := NIL LOCAL oComboBox LOCAL oColumn LOCAL oItems oForm := XbpDialog():new( AppDesktop() ) oForm:drawingArea:clipChildren := .T. oForm:create( ,,{100,100}, {640,480},, .F. ) oForm:close := {|| PostAppEvent( xbeP_Quit )} oComboBox := XbpActiveXControl():new( oForm:drawingArea ) oComboBox:CLSID := "Exontrol.ComboBox.1" /*{CF170E7A-4391-44BD-8D93-29F8D2801EF7}*/ oComboBox:create(,, {10,60},{610,370} ) oColumn := oComboBox:Columns():Add("Column") oColumn:SetProperty("Def",0/*exCellHasCheckBox*/,.T.) oColumn:DisplayFilterButton := .T. oColumn:FilterType := 6/*exCheck*/ oColumn:Filter := Transform(0,"") oComboBox:Items():AddItem(0) oItems := oComboBox:Items() oItems:SetProperty("CellState",oItems:AddItem(1),0,1) oComboBox:Items():AddItem(2) oComboBox:ApplyFilter() oForm:Show() DO WHILE nEvent != xbeP_Quit nEvent := AppEvent( @mp1, @mp2, @oXbp ) oXbp:handleEvent( nEvent, mp1, mp2 ) ENDDO RETURN |
60 |
How can I can I filter programmatically the items based on some numerichal rules
#include "AppEvent.ch" #include "ActiveX.ch" PROCEDURE Main LOCAL oForm LOCAL nEvent := 0, mp1 := NIL, mp2 := NIL, oXbp := NIL LOCAL oComboBox LOCAL oColumn oForm := XbpDialog():new( AppDesktop() ) oForm:drawingArea:clipChildren := .T. oForm:create( ,,{100,100}, {640,480},, .F. ) oForm:close := {|| PostAppEvent( xbeP_Quit )} oComboBox := XbpActiveXControl():new( oForm:drawingArea ) oComboBox:CLSID := "Exontrol.ComboBox.1" /*{CF170E7A-4391-44BD-8D93-29F8D2801EF7}*/ oComboBox:create(,, {10,60},{610,370} ) oColumn := oComboBox:Columns():Add("Column") oColumn:DisplayFilterButton := .T. oColumn:FilterType := 5/*exNumeric*/ oColumn:Filter := "> 0 <= 1" oComboBox:Items():AddItem(0) oComboBox:Items():AddItem(1) oComboBox:Items():AddItem(2) oComboBox:ApplyFilter() oForm:Show() DO WHILE nEvent != xbeP_Quit nEvent := AppEvent( @mp1, @mp2, @oXbp ) oXbp:handleEvent( nEvent, mp1, mp2 ) ENDDO RETURN |
59 |
How can I can I filter programmatically the items based on a range/interval of dates
#include "AppEvent.ch" #include "ActiveX.ch" PROCEDURE Main LOCAL oForm LOCAL nEvent := 0, mp1 := NIL, mp2 := NIL, oXbp := NIL LOCAL oComboBox LOCAL oColumn oForm := XbpDialog():new( AppDesktop() ) oForm:drawingArea:clipChildren := .T. oForm:create( ,,{100,100}, {640,480},, .F. ) oForm:close := {|| PostAppEvent( xbeP_Quit )} oComboBox := XbpActiveXControl():new( oForm:drawingArea ) oComboBox:CLSID := "Exontrol.ComboBox.1" /*{CF170E7A-4391-44BD-8D93-29F8D2801EF7}*/ oComboBox:create(,, {10,60},{610,370} ) oColumn := oComboBox:Columns():Add("Column") oColumn:DisplayFilterButton := .T. oColumn:DisplayFilterDate := .T. oColumn:FilterType := 4/*exDate*/ oColumn:Filter := "1/1/2001 to 1/1/2002" oComboBox:Items():AddItem("1/1/2001") oComboBox:Items():AddItem("2/1/2002") oComboBox:ApplyFilter() oForm:Show() DO WHILE nEvent != xbeP_Quit nEvent := AppEvent( @mp1, @mp2, @oXbp ) oXbp:handleEvent( nEvent, mp1, mp2 ) ENDDO RETURN |
58 |
How can I can I filter programmatically given a specified pattern using wild characters like * or
#include "AppEvent.ch" #include "ActiveX.ch" PROCEDURE Main LOCAL oForm LOCAL nEvent := 0, mp1 := NIL, mp2 := NIL, oXbp := NIL LOCAL oComboBox LOCAL oColumn oForm := XbpDialog():new( AppDesktop() ) oForm:drawingArea:clipChildren := .T. oForm:create( ,,{100,100}, {640,480},, .F. ) oForm:close := {|| PostAppEvent( xbeP_Quit )} oComboBox := XbpActiveXControl():new( oForm:drawingArea ) oComboBox:CLSID := "Exontrol.ComboBox.1" /*{CF170E7A-4391-44BD-8D93-29F8D2801EF7}*/ oComboBox:create(,, {10,60},{610,370} ) oColumn := oComboBox:Columns():Add("Column") oColumn:DisplayFilterButton := .T. oColumn:FilterType := 3/*exPattern*/ oColumn:Filter := "0*" oComboBox:Items():AddItem(0) oComboBox:Items():AddItem("00") oComboBox:Items():AddItem(1) oComboBox:Items():AddItem("11") oComboBox:ApplyFilter() oForm:Show() DO WHILE nEvent != xbeP_Quit nEvent := AppEvent( @mp1, @mp2, @oXbp ) oXbp:handleEvent( nEvent, mp1, mp2 ) ENDDO RETURN |
57 |
How can I can I select programmatically "Blanks/NonBlanks" option in the column's drop down filter
#include "AppEvent.ch" #include "ActiveX.ch" PROCEDURE Main LOCAL oForm LOCAL nEvent := 0, mp1 := NIL, mp2 := NIL, oXbp := NIL LOCAL oComboBox LOCAL oColumn oForm := XbpDialog():new( AppDesktop() ) oForm:drawingArea:clipChildren := .T. oForm:create( ,,{100,100}, {640,480},, .F. ) oForm:close := {|| PostAppEvent( xbeP_Quit )} oComboBox := XbpActiveXControl():new( oForm:drawingArea ) oComboBox:CLSID := "Exontrol.ComboBox.1" /*{CF170E7A-4391-44BD-8D93-29F8D2801EF7}*/ oComboBox:create(,, {10,60},{610,370} ) oColumn := oComboBox:Columns():Add("Column") oColumn:DisplayFilterButton := .T. oColumn:FilterType := 1/*exBlanks*/ oComboBox:ApplyFilter() oForm:Show() DO WHILE nEvent != xbeP_Quit nEvent := AppEvent( @mp1, @mp2, @oXbp ) oXbp:handleEvent( nEvent, mp1, mp2 ) ENDDO RETURN |
56 |
How can I display the column's filter
|
55 |
How can I show the control's grid lines only for added/visible items
|
54 |
Can I hide the hierarchy lines
#include "AppEvent.ch" #include "ActiveX.ch" PROCEDURE Main LOCAL oForm LOCAL nEvent := 0, mp1 := NIL, mp2 := NIL, oXbp := NIL LOCAL oComboBox LOCAL oItems LOCAL h oForm := XbpDialog():new( AppDesktop() ) oForm:drawingArea:clipChildren := .T. oForm:create( ,,{100,100}, {640,480},, .F. ) oForm:close := {|| PostAppEvent( xbeP_Quit )} oComboBox := XbpActiveXControl():new( oForm:drawingArea ) oComboBox:CLSID := "Exontrol.ComboBox.1" /*{CF170E7A-4391-44BD-8D93-29F8D2801EF7}*/ oComboBox:create(,, {10,60},{610,370} ) oComboBox:LinesAtRoot := 1/*exGroupLinesAtRoot*/ oComboBox:HasLines := 0/*exNoLine*/ oComboBox:Columns():Add("Column") oItems := oComboBox:Items() h := oItems:AddItem("Root 1") oItems:InsertItem(h,,"Child 1") oItems:InsertItem(h,,"Child 2") oItems:SetProperty("ExpandItem",h,.T.) h := oItems:AddItem("Root 2") oItems:InsertItem(h,,"Child") oForm:Show() DO WHILE nEvent != xbeP_Quit nEvent := AppEvent( @mp1, @mp2, @oXbp ) oXbp:handleEvent( nEvent, mp1, mp2 ) ENDDO RETURN |
53 |
Can I change the style or type for the hierarchy lines
#include "AppEvent.ch" #include "ActiveX.ch" PROCEDURE Main LOCAL oForm LOCAL nEvent := 0, mp1 := NIL, mp2 := NIL, oXbp := NIL LOCAL oComboBox LOCAL oItems LOCAL h oForm := XbpDialog():new( AppDesktop() ) oForm:drawingArea:clipChildren := .T. oForm:create( ,,{100,100}, {640,480},, .F. ) oForm:close := {|| PostAppEvent( xbeP_Quit )} oComboBox := XbpActiveXControl():new( oForm:drawingArea ) oComboBox:CLSID := "Exontrol.ComboBox.1" /*{CF170E7A-4391-44BD-8D93-29F8D2801EF7}*/ oComboBox:create(,, {10,60},{610,370} ) oComboBox:LinesAtRoot := 1/*exGroupLinesAtRoot*/ oComboBox:HasLines := 2/*exThinLine*/ oComboBox:Columns():Add("Column") oItems := oComboBox:Items() h := oItems:AddItem("Root 1") oItems:InsertItem(h,,"Child 1") oItems:InsertItem(h,,"Child 2") oItems:SetProperty("ExpandItem",h,.T.) h := oItems:AddItem("Root 2") oItems:InsertItem(h,,"Child") oForm:Show() DO WHILE nEvent != xbeP_Quit nEvent := AppEvent( @mp1, @mp2, @oXbp ) oXbp:handleEvent( nEvent, mp1, mp2 ) ENDDO RETURN |
52 |
Can I use my own icons for the +/- ( expand/collapse ) buttons
#include "AppEvent.ch" #include "ActiveX.ch" PROCEDURE Main LOCAL oForm LOCAL nEvent := 0, mp1 := NIL, mp2 := NIL, oXbp := NIL LOCAL oComboBox LOCAL oItems LOCAL h oForm := XbpDialog():new( AppDesktop() ) oForm:drawingArea:clipChildren := .T. oForm:create( ,,{100,100}, {640,480},, .F. ) oForm:close := {|| PostAppEvent( xbeP_Quit )} oComboBox := XbpActiveXControl():new( oForm:drawingArea ) oComboBox:CLSID := "Exontrol.ComboBox.1" /*{CF170E7A-4391-44BD-8D93-29F8D2801EF7}*/ oComboBox:create(,, {10,60},{610,370} ) oComboBox:Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTqlVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/yNAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=") oComboBox:LinesAtRoot := 1/*exGroupLinesAtRoot*/ oComboBox:HasButtons := 4/*exCustom*/ oComboBox:SetProperty("HasButtonsCustom",.F.,1) oComboBox:SetProperty("HasButtonsCustom",.T.,2) oComboBox:Columns():Add("Column") oItems := oComboBox:Items() h := oItems:AddItem("Root 1") oItems:InsertItem(h,,"Child 1") oItems:InsertItem(h,,"Child 2") oItems:SetProperty("ExpandItem",h,.T.) h := oItems:AddItem("Root 2") oItems:InsertItem(h,,"Child") oForm:Show() DO WHILE nEvent != xbeP_Quit nEvent := AppEvent( @mp1, @mp2, @oXbp ) oXbp:handleEvent( nEvent, mp1, mp2 ) ENDDO RETURN |
51 |
How do I change visual appearance of the +/- ( expand/collapse ) buttons
#include "AppEvent.ch" #include "ActiveX.ch" PROCEDURE Main LOCAL oForm LOCAL nEvent := 0, mp1 := NIL, mp2 := NIL, oXbp := NIL LOCAL oComboBox LOCAL oItems LOCAL h oForm := XbpDialog():new( AppDesktop() ) oForm:drawingArea:clipChildren := .T. oForm:create( ,,{100,100}, {640,480},, .F. ) oForm:close := {|| PostAppEvent( xbeP_Quit )} oComboBox := XbpActiveXControl():new( oForm:drawingArea ) oComboBox:CLSID := "Exontrol.ComboBox.1" /*{CF170E7A-4391-44BD-8D93-29F8D2801EF7}*/ oComboBox:create(,, {10,60},{610,370} ) oComboBox:LinesAtRoot := 1/*exGroupLinesAtRoot*/ oComboBox:HasButtons := 3/*exWPlus*/ oComboBox:Columns():Add("Column") oItems := oComboBox:Items() h := oItems:AddItem("Root 1") oItems:InsertItem(h,,"Child 1") oItems:InsertItem(h,,"Child 2") oItems:SetProperty("ExpandItem",h,.T.) h := oItems:AddItem("Root 2") oItems:InsertItem(h,,"Child") oForm:Show() DO WHILE nEvent != xbeP_Quit nEvent := AppEvent( @mp1, @mp2, @oXbp ) oXbp:handleEvent( nEvent, mp1, mp2 ) ENDDO RETURN |
50 |
How can I change the "IsChecked/IsUnchecked" caption in the control's filter bar, when I filter for checked items
|
49 |
How can I change the "Checked" caption in the drop down filter window, when I filter for checked items
|
48 |
How can I change the name of the week days in the drop down calendar window, being displayed when I filter items between dates
|
47 |
How can I change the name of the months in the drop down calendar window, being displayed when I filter items between dates
|
46 |
Can I change the "Today" caption being displayed in the drop down calendar, when I filter for dates
|
45 |
The drop down filter window displays a "to" string between two datem when I filter dates. Can I change that
|
44 |
How can I filter the items that are between an interval/range of dates
|
43 |
Can I change the "Date:" caption when the column's drop down filter window is shown
|
42 |
Can I filter for values using OR - NOT , instead AND operator
|
41 |
Can I change the NOT string in the filter bar
|
40 |
How do I ensure that the focused item is visible, after the user does the sort
|
39 |
Can I change the OR string in the filter bar
|
38 |
Can I change the AND string in the filter bar
#include "AppEvent.ch" #include "ActiveX.ch" PROCEDURE Main LOCAL oForm LOCAL nEvent := 0, mp1 := NIL, mp2 := NIL, oXbp := NIL LOCAL oComboBox LOCAL oColumn,oColumn1 oForm := XbpDialog():new( AppDesktop() ) oForm:drawingArea:clipChildren := .T. oForm:create( ,,{100,100}, {640,480},, .F. ) oForm:close := {|| PostAppEvent( xbeP_Quit )} oComboBox := XbpActiveXControl():new( oForm:drawingArea ) oComboBox:CLSID := "Exontrol.ComboBox.1" /*{CF170E7A-4391-44BD-8D93-29F8D2801EF7}*/ oComboBox:create(,, {10,60},{610,370} ) oColumn := oComboBox:Columns():Add("Column 1") oColumn:DisplayFilterButton := .T. oColumn:FilterType := 1/*exBlanks*/ oColumn1 := oComboBox:Columns():Add("Column 2") oColumn1:DisplayFilterButton := .T. oColumn1:FilterType := 2/*exNonBlanks*/ oComboBox:SetProperty("Description",11/*exFilterBarAnd*/," & ") oComboBox:ApplyFilter() oForm:Show() DO WHILE nEvent != xbeP_Quit nEvent := AppEvent( @mp1, @mp2, @oXbp ) oXbp:handleEvent( nEvent, mp1, mp2 ) ENDDO RETURN |
37 |
The "IsBlank" caption shown in the control's filterbar when I select "Blanks" or "NonBlanks" items in the column's drop down filter window
#include "AppEvent.ch" #include "ActiveX.ch" PROCEDURE Main LOCAL oForm LOCAL nEvent := 0, mp1 := NIL, mp2 := NIL, oXbp := NIL LOCAL oComboBox LOCAL oColumn oForm := XbpDialog():new( AppDesktop() ) oForm:drawingArea:clipChildren := .T. oForm:create( ,,{100,100}, {640,480},, .F. ) oForm:close := {|| PostAppEvent( xbeP_Quit )} oComboBox := XbpActiveXControl():new( oForm:drawingArea ) oComboBox:CLSID := "Exontrol.ComboBox.1" /*{CF170E7A-4391-44BD-8D93-29F8D2801EF7}*/ oComboBox:create(,, {10,60},{610,370} ) oColumn := oComboBox:Columns():Add("Column") oColumn:DisplayFilterButton := .T. oColumn:FilterType := 1/*exBlanks*/ oComboBox:SetProperty("Description",9/*exFilterBarIsBlank*/,"Is Empty") oComboBox:SetProperty("Description",10/*exFilterBarIsNonBlank*/,"Is Not Empty") oComboBox:ApplyFilter() oForm:Show() DO WHILE nEvent != xbeP_Quit nEvent := AppEvent( @mp1, @mp2, @oXbp ) oXbp:handleEvent( nEvent, mp1, mp2 ) ENDDO RETURN |
36 |
Is there any option to remove the tooltip when the cursor hovers the column's drop down filter window
#include "AppEvent.ch" #include "ActiveX.ch" PROCEDURE Main LOCAL oForm LOCAL nEvent := 0, mp1 := NIL, mp2 := NIL, oXbp := NIL LOCAL oComboBox oForm := XbpDialog():new( AppDesktop() ) oForm:drawingArea:clipChildren := .T. oForm:create( ,,{100,100}, {640,480},, .F. ) oForm:close := {|| PostAppEvent( xbeP_Quit )} oComboBox := XbpActiveXControl():new( oForm:drawingArea ) oComboBox:CLSID := "Exontrol.ComboBox.1" /*{CF170E7A-4391-44BD-8D93-29F8D2801EF7}*/ oComboBox:create(,, {10,60},{610,370} ) oComboBox:Columns():Add("Column"):DisplayFilterButton := .T. oComboBox:SetProperty("Description",4/*exFilterBarFilterTitle*/,"") oComboBox:SetProperty("Description",5/*exFilterBarPatternFilterTitle*/,"") oComboBox:SetProperty("Description",6/*exFilterBarTooltip*/,"") oComboBox:SetProperty("Description",7/*exFilterBarPatternTooltip*/,"") oComboBox:SetProperty("Description",8/*exFilterBarFilterForTooltip*/,"") oComboBox:SetProperty("Description",14/*exFilterBarDateTooltip*/,"") oComboBox:SetProperty("Description",15/*exFilterBarDateTitle*/,"") oForm:Show() DO WHILE nEvent != xbeP_Quit nEvent := AppEvent( @mp1, @mp2, @oXbp ) oXbp:handleEvent( nEvent, mp1, mp2 ) ENDDO RETURN |
35 |
How can I change the "Filter For" caption in the column's drop down filter window
#include "AppEvent.ch" #include "ActiveX.ch" PROCEDURE Main LOCAL oForm LOCAL nEvent := 0, mp1 := NIL, mp2 := NIL, oXbp := NIL LOCAL oComboBox oForm := XbpDialog():new( AppDesktop() ) oForm:drawingArea:clipChildren := .T. oForm:create( ,,{100,100}, {640,480},, .F. ) oForm:close := {|| PostAppEvent( xbeP_Quit )} oComboBox := XbpActiveXControl():new( oForm:drawingArea ) oComboBox:CLSID := "Exontrol.ComboBox.1" /*{CF170E7A-4391-44BD-8D93-29F8D2801EF7}*/ oComboBox:create(,, {10,60},{610,370} ) oComboBox:Columns():Add("Column"):DisplayFilterButton := .T. oComboBox:SetProperty("Description",3/*exFilterBarFilterForCaption*/,"new caption") oForm:Show() DO WHILE nEvent != xbeP_Quit nEvent := AppEvent( @mp1, @mp2, @oXbp ) oXbp:handleEvent( nEvent, mp1, mp2 ) ENDDO RETURN |
34 |
Can I remove the "All", "Blanks" and "NonBlanks" items in the drop down filter window
#include "AppEvent.ch" #include "ActiveX.ch" PROCEDURE Main LOCAL oForm LOCAL nEvent := 0, mp1 := NIL, mp2 := NIL, oXbp := NIL LOCAL oComboBox oForm := XbpDialog():new( AppDesktop() ) oForm:drawingArea:clipChildren := .T. oForm:create( ,,{100,100}, {640,480},, .F. ) oForm:close := {|| PostAppEvent( xbeP_Quit )} oComboBox := XbpActiveXControl():new( oForm:drawingArea ) oComboBox:CLSID := "Exontrol.ComboBox.1" /*{CF170E7A-4391-44BD-8D93-29F8D2801EF7}*/ oComboBox:create(,, {10,60},{610,370} ) oComboBox:Columns():Add("Column"):DisplayFilterButton := .T. oComboBox:SetProperty("Description",0/*exFilterBarAll*/,"") oComboBox:SetProperty("Description",1/*exFilterBarBlanks*/,"") oComboBox:SetProperty("Description",2/*exFilterBarNonBlanks*/,"") oForm:Show() DO WHILE nEvent != xbeP_Quit nEvent := AppEvent( @mp1, @mp2, @oXbp ) oXbp:handleEvent( nEvent, mp1, mp2 ) ENDDO RETURN |
33 |
How do I change the "All", "Blanks" or/and "NonBlanks" caption in the drop down filter window
#include "AppEvent.ch" #include "ActiveX.ch" PROCEDURE Main LOCAL oForm LOCAL nEvent := 0, mp1 := NIL, mp2 := NIL, oXbp := NIL LOCAL oComboBox oForm := XbpDialog():new( AppDesktop() ) oForm:drawingArea:clipChildren := .T. oForm:create( ,,{100,100}, {640,480},, .F. ) oForm:close := {|| PostAppEvent( xbeP_Quit )} oComboBox := XbpActiveXControl():new( oForm:drawingArea ) oComboBox:CLSID := "Exontrol.ComboBox.1" /*{CF170E7A-4391-44BD-8D93-29F8D2801EF7}*/ oComboBox:create(,, {10,60},{610,370} ) oComboBox:Columns():Add("Column"):DisplayFilterButton := .T. oComboBox:SetProperty("Description",0/*exFilterBarAll*/,"new name for (All)") oForm:Show() DO WHILE nEvent != xbeP_Quit nEvent := AppEvent( @mp1, @mp2, @oXbp ) oXbp:handleEvent( nEvent, mp1, mp2 ) ENDDO RETURN |
32 |
How can I change the position of the column
|
31 |
Can I make strikeout the column's header
#include "AppEvent.ch" #include "ActiveX.ch" PROCEDURE Main LOCAL oForm LOCAL nEvent := 0, mp1 := NIL, mp2 := NIL, oXbp := NIL LOCAL oComboBox oForm := XbpDialog():new( AppDesktop() ) oForm:drawingArea:clipChildren := .T. oForm:create( ,,{100,100}, {640,480},, .F. ) oForm:close := {|| PostAppEvent( xbeP_Quit )} oComboBox := XbpActiveXControl():new( oForm:drawingArea ) oComboBox:CLSID := "Exontrol.ComboBox.1" /*{CF170E7A-4391-44BD-8D93-29F8D2801EF7}*/ oComboBox:create(,, {10,60},{610,370} ) oComboBox:Columns():Add("Column 1"):HeaderStrikeOut := .T. oForm:Show() DO WHILE nEvent != xbeP_Quit nEvent := AppEvent( @mp1, @mp2, @oXbp ) oXbp:handleEvent( nEvent, mp1, mp2 ) ENDDO RETURN |
30 |
How can I apply an strikeout font only a portion of the column's header
|
29 |
How can I get underlined only a portion of column's header
|
28 |
How can I underline the column's header
|
27 |
How can I apply an italic font only a portion of the column's header
|
26 |
Is there any option to make italic the column's header
|
25 |
How can I bold only a portion of the column's header
|
24 |
Is there any option to bold the column's header
|
23 |
Why child items are not shown
#include "AppEvent.ch" #include "ActiveX.ch" PROCEDURE Main LOCAL oForm LOCAL nEvent := 0, mp1 := NIL, mp2 := NIL, oXbp := NIL LOCAL oComboBox LOCAL oItems LOCAL h oForm := XbpDialog():new( AppDesktop() ) oForm:drawingArea:clipChildren := .T. oForm:create( ,,{100,100}, {640,480},, .F. ) oForm:close := {|| PostAppEvent( xbeP_Quit )} oComboBox := XbpActiveXControl():new( oForm:drawingArea ) oComboBox:CLSID := "Exontrol.ComboBox.1" /*{CF170E7A-4391-44BD-8D93-29F8D2801EF7}*/ oComboBox:create(,, {10,60},{610,370} ) oComboBox:LinesAtRoot := -1/*exLinesAtRoot*/ oComboBox:Columns():Add("Column 1") oItems := oComboBox:Items() h := oItems:AddItem("Root") oItems:InsertItem(h,,"Child 1") oItems:InsertItem(h,,"Child 2") oItems:SetProperty("ExpandItem",h,.T.) oForm:Show() DO WHILE nEvent != xbeP_Quit nEvent := AppEvent( @mp1, @mp2, @oXbp ) oXbp:handleEvent( nEvent, mp1, mp2 ) ENDDO RETURN |
22 |
Does your control support partial-check ( three states ) feature for each column
#include "AppEvent.ch" #include "ActiveX.ch" PROCEDURE Main LOCAL oForm LOCAL nEvent := 0, mp1 := NIL, mp2 := NIL, oXbp := NIL LOCAL oComboBox LOCAL oColumn,oColumn1 LOCAL oItems LOCAL h oForm := XbpDialog():new( AppDesktop() ) oForm:drawingArea:clipChildren := .T. oForm:create( ,,{100,100}, {640,480},, .F. ) oForm:close := {|| PostAppEvent( xbeP_Quit )} oComboBox := XbpActiveXControl():new( oForm:drawingArea ) oComboBox:CLSID := "Exontrol.ComboBox.1" /*{CF170E7A-4391-44BD-8D93-29F8D2801EF7}*/ oComboBox:create(,, {10,60},{610,370} ) oComboBox:LinesAtRoot := -1/*exLinesAtRoot*/ oColumn := oComboBox:Columns():Add("P1") oColumn:SetProperty("Def",0/*exCellHasCheckBox*/,.T.) oColumn:PartialCheck := .T. oColumn1 := oComboBox:Columns():Add("P2") oColumn1:SetProperty("Def",0/*exCellHasCheckBox*/,.T.) oColumn1:PartialCheck := .T. oItems := oComboBox:Items() h := oItems:AddItem("Root") oItems:InsertItem(h,,"Child 1") oItems:InsertItem(h,,"Child 2") oItems:SetProperty("ExpandItem",h,.T.) oForm:Show() DO WHILE nEvent != xbeP_Quit nEvent := AppEvent( @mp1, @mp2, @oXbp ) oXbp:handleEvent( nEvent, mp1, mp2 ) ENDDO RETURN |
21 |
Can I change the font to display the column's header
#include "AppEvent.ch" #include "ActiveX.ch" PROCEDURE Main LOCAL oForm LOCAL nEvent := 0, mp1 := NIL, mp2 := NIL, oXbp := NIL LOCAL oComboBox oForm := XbpDialog():new( AppDesktop() ) oForm:drawingArea:clipChildren := .T. oForm:create( ,,{100,100}, {640,480},, .F. ) oForm:close := {|| PostAppEvent( xbeP_Quit )} oComboBox := XbpActiveXControl():new( oForm:drawingArea ) oComboBox:CLSID := "Exontrol.ComboBox.1" /*{CF170E7A-4391-44BD-8D93-29F8D2801EF7}*/ oComboBox:create(,, {10,60},{610,370} ) oComboBox:HeaderHeight := 34 oComboBox:Columns():Add("Column 1"):HTMLCaption := "<font Tahoma;14>Column</font> 1" oForm:Show() DO WHILE nEvent != xbeP_Quit nEvent := AppEvent( @mp1, @mp2, @oXbp ) oXbp:handleEvent( nEvent, mp1, mp2 ) ENDDO RETURN |
20 |
Can I change the height of the header bar
|
19 |
Can I display multiple icons to the column's header
|
18 |
How can I draw grid lines only for visible items
|
17 |
How can I show the control's grid lines
|
16 |
How can I assign a different background color for the entire column
#include "AppEvent.ch" #include "ActiveX.ch" PROCEDURE Main LOCAL oForm LOCAL nEvent := 0, mp1 := NIL, mp2 := NIL, oXbp := NIL LOCAL oComboBox oForm := XbpDialog():new( AppDesktop() ) oForm:drawingArea:clipChildren := .T. oForm:create( ,,{100,100}, {640,480},, .F. ) oForm:close := {|| PostAppEvent( xbeP_Quit )} oComboBox := XbpActiveXControl():new( oForm:drawingArea ) oComboBox:CLSID := "Exontrol.ComboBox.1" /*{CF170E7A-4391-44BD-8D93-29F8D2801EF7}*/ oComboBox:create(,, {10,60},{610,370} ) oComboBox:MarkSearchColumn := .F. oComboBox:Columns():Add("Column 1"):SetProperty("Def",4/*exCellBackColor*/,255) oComboBox:Columns():Add("Column 2") oComboBox:Items():AddItem(0) oComboBox:Items():AddItem(1) oComboBox:Items():AddItem(2) oForm:Show() DO WHILE nEvent != xbeP_Quit nEvent := AppEvent( @mp1, @mp2, @oXbp ) oXbp:handleEvent( nEvent, mp1, mp2 ) ENDDO RETURN |
15 |
How can I assign a check box for a cell
#include "AppEvent.ch" #include "ActiveX.ch" PROCEDURE Main LOCAL oForm LOCAL nEvent := 0, mp1 := NIL, mp2 := NIL, oXbp := NIL LOCAL oComboBox LOCAL oItems oForm := XbpDialog():new( AppDesktop() ) oForm:drawingArea:clipChildren := .T. oForm:create( ,,{100,100}, {640,480},, .F. ) oForm:close := {|| PostAppEvent( xbeP_Quit )} oComboBox := XbpActiveXControl():new( oForm:drawingArea ) oComboBox:CLSID := "Exontrol.ComboBox.1" /*{CF170E7A-4391-44BD-8D93-29F8D2801EF7}*/ oComboBox:create(,, {10,60},{610,370} ) oComboBox:Columns():Add("Column 1") oItems := oComboBox:Items() oItems:AddItem(0) oItems:SetProperty("CellHasCheckBox",oItems:AddItem(1),0,.T.) oItems:AddItem(2) oForm:Show() DO WHILE nEvent != xbeP_Quit nEvent := AppEvent( @mp1, @mp2, @oXbp ) oXbp:handleEvent( nEvent, mp1, mp2 ) ENDDO RETURN |
14 |
How can I assign checkboxes for the entire column
#include "AppEvent.ch" #include "ActiveX.ch" PROCEDURE Main LOCAL oForm LOCAL nEvent := 0, mp1 := NIL, mp2 := NIL, oXbp := NIL LOCAL oComboBox oForm := XbpDialog():new( AppDesktop() ) oForm:drawingArea:clipChildren := .T. oForm:create( ,,{100,100}, {640,480},, .F. ) oForm:close := {|| PostAppEvent( xbeP_Quit )} oComboBox := XbpActiveXControl():new( oForm:drawingArea ) oComboBox:CLSID := "Exontrol.ComboBox.1" /*{CF170E7A-4391-44BD-8D93-29F8D2801EF7}*/ oComboBox:create(,, {10,60},{610,370} ) oComboBox:Columns():Add("Column 1"):SetProperty("Def",0/*exCellHasCheckBox*/,.T.) oComboBox:Items():AddItem(0) oComboBox:Items():AddItem(1) oComboBox:Items():AddItem(2) oForm:Show() DO WHILE nEvent != xbeP_Quit nEvent := AppEvent( @mp1, @mp2, @oXbp ) oXbp:handleEvent( nEvent, mp1, mp2 ) ENDDO RETURN |
13 |
How can I change the column's width
#include "AppEvent.ch" #include "ActiveX.ch" PROCEDURE Main LOCAL oForm LOCAL nEvent := 0, mp1 := NIL, mp2 := NIL, oXbp := NIL LOCAL oComboBox oForm := XbpDialog():new( AppDesktop() ) oForm:drawingArea:clipChildren := .T. oForm:create( ,,{100,100}, {640,480},, .F. ) oForm:close := {|| PostAppEvent( xbeP_Quit )} oComboBox := XbpActiveXControl():new( oForm:drawingArea ) oComboBox:CLSID := "Exontrol.ComboBox.1" /*{CF170E7A-4391-44BD-8D93-29F8D2801EF7}*/ oComboBox:create(,, {10,60},{610,370} ) oComboBox:ColumnAutoResize := .F. oComboBox:Columns():Add("Column 1"):Width := 64 oComboBox:Columns():Add("Column 2"):Width := 128 oForm:Show() DO WHILE nEvent != xbeP_Quit nEvent := AppEvent( @mp1, @mp2, @oXbp ) oXbp:handleEvent( nEvent, mp1, mp2 ) ENDDO RETURN |
12 |
How can I show or hide a column
|
11 |
How can I hide the searching column
|
10 |
Can I disable sorting a column, when the user clicks the column's header, or drag it to the sort bar
|
9 |
Is there any option to align the header to the left and the data to the right
#include "AppEvent.ch" #include "ActiveX.ch" PROCEDURE Main LOCAL oForm LOCAL nEvent := 0, mp1 := NIL, mp2 := NIL, oXbp := NIL LOCAL oComboBox LOCAL oColumn LOCAL oItems oForm := XbpDialog():new( AppDesktop() ) oForm:drawingArea:clipChildren := .T. oForm:create( ,,{100,100}, {640,480},, .F. ) oForm:close := {|| PostAppEvent( xbeP_Quit )} oComboBox := XbpActiveXControl():new( oForm:drawingArea ) oComboBox:CLSID := "Exontrol.ComboBox.1" /*{CF170E7A-4391-44BD-8D93-29F8D2801EF7}*/ oComboBox:create(,, {10,60},{610,370} ) oComboBox:Columns():Add("Left"):Alignment := 0/*LeftAlignment*/ oColumn := oComboBox:Columns():Add("Right") oColumn:Alignment := 2/*RightAlignment*/ oColumn:HeaderAlignment := 2/*RightAlignment*/ oItems := oComboBox:Items() oItems:SetProperty("CellCaption",oItems:AddItem("left"),1,"right") oForm:Show() DO WHILE nEvent != xbeP_Quit nEvent := AppEvent( @mp1, @mp2, @oXbp ) oXbp:handleEvent( nEvent, mp1, mp2 ) ENDDO RETURN |
8 |
Can I displays a custom size picture to column's header
#include "AppEvent.ch" #include "ActiveX.ch" PROCEDURE Main LOCAL oForm LOCAL nEvent := 0, mp1 := NIL, mp2 := NIL, oXbp := NIL LOCAL oComboBox oForm := XbpDialog():new( AppDesktop() ) oForm:drawingArea:clipChildren := .T. oForm:create( ,,{100,100}, {640,480},, .F. ) oForm:close := {|| PostAppEvent( xbeP_Quit )} oComboBox := XbpActiveXControl():new( oForm:drawingArea ) oComboBox:CLSID := "Exontrol.ComboBox.1" /*{CF170E7A-4391-44BD-8D93-29F8D2801EF7}*/ oComboBox:create(,, {10,60},{610,370} ) oComboBox:SetProperty("HTMLPicture","pic1","c:\exontrol\images\zipdisk.gif") oComboBox:HeaderHeight := 48 oComboBox:Columns():Add("ColumnName"):HTMLCaption := "<b>HTML</b> Column <img>pic1</img> Picture" oForm:Show() DO WHILE nEvent != xbeP_Quit nEvent := AppEvent( @mp1, @mp2, @oXbp ) oXbp:handleEvent( nEvent, mp1, mp2 ) ENDDO RETURN |
7 |
How can I insert an icon to column's header
|
6 |
How can I insert an icon to column's header
|
5 |
How can I use HTML format in column's header
|
4 |
How can I change/rename the column's name
|
3 |
How can I add multiple columns
#include "AppEvent.ch" #include "ActiveX.ch" PROCEDURE Main LOCAL oForm LOCAL nEvent := 0, mp1 := NIL, mp2 := NIL, oXbp := NIL LOCAL oComboBox LOCAL oColumns oForm := XbpDialog():new( AppDesktop() ) oForm:drawingArea:clipChildren := .T. oForm:create( ,,{100,100}, {640,480},, .F. ) oForm:close := {|| PostAppEvent( xbeP_Quit )} oComboBox := XbpActiveXControl():new( oForm:drawingArea ) oComboBox:CLSID := "Exontrol.ComboBox.1" /*{CF170E7A-4391-44BD-8D93-29F8D2801EF7}*/ oComboBox:create(,, {10,60},{610,370} ) oColumns := oComboBox:Columns() oColumns:Add("Column 1") oColumns:Add("Column 2") oForm:Show() DO WHILE nEvent != xbeP_Quit nEvent := AppEvent( @mp1, @mp2, @oXbp ) oXbp:handleEvent( nEvent, mp1, mp2 ) ENDDO RETURN |
2 |
I've added a single column, but it is displayed only on a part of the control. Is there something I can do so the column will be fully displayed on the control
#include "AppEvent.ch" #include "ActiveX.ch" PROCEDURE Main LOCAL oForm LOCAL nEvent := 0, mp1 := NIL, mp2 := NIL, oXbp := NIL LOCAL oComboBox oForm := XbpDialog():new( AppDesktop() ) oForm:drawingArea:clipChildren := .T. oForm:create( ,,{100,100}, {640,480},, .F. ) oForm:close := {|| PostAppEvent( xbeP_Quit )} oComboBox := XbpActiveXControl():new( oForm:drawingArea ) oComboBox:CLSID := "Exontrol.ComboBox.1" /*{CF170E7A-4391-44BD-8D93-29F8D2801EF7}*/ oComboBox:create(,, {10,60},{610,370} ) oComboBox:Columns():Add("ColumnName") oComboBox:Items():AddItem("Item 1") oComboBox:Items():AddItem("Item 2") oForm:Show() DO WHILE nEvent != xbeP_Quit nEvent := AppEvent( @mp1, @mp2, @oXbp ) oXbp:handleEvent( nEvent, mp1, mp2 ) ENDDO RETURN |
1 |
How can I add a new column
|